SOP 1: Database using LibreOffice Base
Create a table student with fieldnames rollno, studname, class, div, city, dob etc.; insert minimum 8 records; create a form based on the student table.
Solution
i) Steps for creating a database
- Click Start → All Programs → LibreOffice → LibreOffice Base.
- When the Database wizard appears, choose Save and proceed → Click Finish → select location and name to save the database; the database will be created.
ii) Steps for creating a table
To create the student table in Design View and set fields:
- Click on Create table in design view → Table design window appears; define fieldnames and datatypes (e.g., rollno Integer, studname VARCHAR, class VARCHAR, div CHAR, city VARCHAR, dob Date).
- To assign PRIMARY KEY to rollno, right-click the small box at the left of the field and select Primary key.
- Save the table (Ctrl+S), name it student and click OK to store it.
iii) Steps for inserting records in a table
- Double-click the student table to open the data entry sheet; type the records under each field and complete at least 8 entries.
iv) Steps for creating a form
- From the left pane select the Forms object.
- Choose the table name (student), then shift fields from Available fields to Fields in form using the arrow and click Next.
- Set labels for fields and click Next.
- Choose an arrangement for the main form controls and click Next.
- Select style for the form and click Next, then Finish to create the form.
Notes
- Use appropriate datatypes for date and numeric fields to avoid formatting issues.
- Set rollno as Primary Key to ensure uniqueness.
- Save the database and form for future data entry and report generation.